microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 26

In Excel default style for new data keyed in a new workbook is

a) Comma

b) Currency

c) Normal

d) Per cent

Question : 27

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you

a) Press the Erase key

b) Press Esc

c) Press the Enter button

d) Press the Edit Formula button

e) None of these

Question : 28

In Excel you can add a hyperlink to your worksheet by pressing

a) Alt + K

b) Ctrl + H

c) Ctrl + K

d) Ctrl + Shift + K

Question : 29

In Excel A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button

a) nothing will print because some cells with data have been omitted

b) only the cells with gray background will print

c) the whole sheet will print

d) only the cells with white background will print

Question : 30

How do you change column width to fit the contents?

a) Single-click the boundary to the left to the column heading

b) Double click the boundary to the right of the column heading

c) Press Alt and single click anywhere in the column

d) All of above

e) None of these